Diagram SCHED_Scheduler

Defincja diagramu SCHED_Scheduler

Name

SCHED_Scheduler

Code

SCHED_Scheduler

Comment

 


Lista tabel diagramu

Name

Code

Day

Day

Frequency

Frequency

FrequencyText

FrequencyText

Holiday

Holiday

Job

Job

JobText

JobText

JobTime

JobTime

JobTimeText

JobTimeText

JobType

JobType

JobTypeText

JobTypeText

Language

Language

LFrequencyTimeTemplate

LFrequencyTimeTemplate

LMedResourceHoliday

LMedResourceHoliday

LMedResourceOrgUnit

LMedResourceOrgUnit

LMedResourceOrgUnitJob

LMedResourceOrgUnitJob

LOrgUnitHoliday

LOrgUnitHoliday

LPersonnelType

LPersonnelType

LTimeSlotTypeOrgUnit

LTimeSlotTypeOrgUnit

LVisitTimeSlot

LVisitTimeSlot

LVisitTimeSlotChange

LVisitTimeSlotChange

LVisitTypeTemplate

LVisitTypeTemplate

LVisitTypeTimeSlot

LVisitTypeTimeSlot

MedResource

MedResource

PersonnelType

PersonnelType

Reason

Reason

ReasonText

ReasonText

ReasonType

ReasonType

ReasonTypeText

ReasonTypeText

Scheduler

Scheduler

SchedulerDataHist

SchedulerDataHist

TemplateDay

TemplateDay

TemplateTimeSlot

TemplateTimeSlot

TemplateType

TemplateType

TemplateTypeText

TemplateTypeText

TimeSlot

TimeSlot

TimeSlotMetaType

TimeSlotMetaType

TimeSlotMetaTypeText

TimeSlotMetaTypeText

TimeSlotStatus

TimeSlotStatus

TimeSlotStatusText

TimeSlotStatusText

TimeSlotType

TimeSlotType

TimeSlotTypeText

TimeSlotTypeText

TimeTemplate

TimeTemplate

Visit

Visit

VisitType

VisitType


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_110

R_110

TemplateType

TemplateTypeText

TemplateTypeID

 

 

R_111

R_111

Language

TemplateTypeText

LanguageID

 

 

R_165

R_165

Reason

LVisitTimeSlotChange

ReasonID

 

 

R_174

R_174

Frequency

LFrequencyTimeTemplate

FrequencyID

 

 

R_176

R_176

TimeTemplate

LFrequencyTimeTemplate

TimeTemplateID

 

 

R_367

R_367

PersonnelType

LPersonnelType

PersonnelTypeID

 

 

R_382

R_382

Scheduler

Day

SchedulerID

 

 

R_383

R_383

Frequency

TemplateDay

FrequencyID

 

 

R_384

R_384

Frequency

FrequencyText

FrequencyID

 

 

R_385

R_385

Language

FrequencyText

LanguageID

 

 

R_386

R_386

Day

TimeSlot

DayID

 

 

R_387

R_387

TemplateDay

TemplateTimeSlot

TemplateDayID

 

 

R_388

R_388

TimeSlot

LVisitTypeTimeSlot

TimeSlotID

 

 

R_389

R_389

TemplateTimeSlot

LVisitTypeTemplate

TemplateTimeSlotID

 

 

R_390

R_390

VisitType

LVisitTypeTimeSlot

VisitTypeID

 

 

R_391

R_391

VisitType

LVisitTypeTemplate

VisitTypeID

 

 

R_392

R_392

Visit

LVisitTimeSlot

VisitID

 

 

R_393

R_393

TimeSlot

LVisitTimeSlot

TimeSlotID

 

 

R_395

R_395

LMedResourceOrgUnit

Scheduler

MedResourceID

 

 

R_400

R_400

MedResource

LMedResourceOrgUnit

MedResourceID

 

 

R_411

R_411

VisitType

Visit

VisitTypeID

 

 

R_426

R_426

Holiday

LOrgUnitHoliday

HolidayID

 

 

R_704

R_704

Frequency

Holiday

FrequencyID

 

 

R_705

R_705

Holiday

LMedResourceHoliday

HolidayID

 

 

R_706

R_706

LMedResourceOrgUnit

LMedResourceHoliday

MedResourceID

 

 

R_815

R_815

TimeSlotType

TimeSlot

TimeslotTypeID

 

 

R_816

R_816

TimeSlotType

TimeSlotTypeText

TimeslotTypeID

 

 

R_817

R_817

Language

TimeSlotTypeText

LanguageID

 

 

R_818

R_818

TimeSlotType

LTimeSlotTypeOrgUnit

TimeslotTypeID

 

 

R_820

R_820

TimeSlotStatus

TimeSlot

TimeSlotStatusID

 

 

R_821

R_821

TimeSlotStatus

TimeSlotStatusText

TimeSlotStatusID

 

 

R_822

R_822

Language

TimeSlotStatusText

LanguageID

 

 

R_844

R_844

PersonnelType

LTimeSlotTypeOrgUnit

PersonnelTypeID

 

 

R_888

R_888

TimeSlotMetaType

TimeSlotType

TimeSlotMetaTypeID

 

 

R_889

R_889

TimeSlotMetaType

TimeSlotMetaTypeText

TimeSlotMetaTypeID

 

 

R_890

R_890

Language

TimeSlotMetaTypeText

LanguageID

 

 

R_893

R_893

LPersonnelType

LMedResourceOrgUnit

LPersonnelTypeID

 

 

R_956

R_956

Reason

ReasonText

ReasonID

 

 

R_957

R_957

Language

ReasonText

LanguageID

 

 

R_958

R_958

TimeSlot

LVisitTimeSlotChange

Tim_TimeSlotID

 

 

R_959

R_959

TimeSlot

LVisitTimeSlotChange

TimeSlotID

 

 

R_960

R_960

Visit

LVisitTimeSlotChange

VisitID

 

 

R_1104

R_1104

JobTime

Job

JobTimeID

 

 

R_1118

R_1118

LMedResourceOrgUnit

LMedResourceOrgUnitJob

MedResourceID

 

 

R_1119

R_1119

Job

LMedResourceOrgUnitJob

JobID

 

 

R_1120

R_1120

LPersonnelType

LMedResourceOrgUnitJob

LPersonnelTypeID

 

 

R_1452

R_1452

Job

JobText

JobID

 

 

R_1453

R_1453

Language

JobText

LanguageID

 

 

R_8300

R_8300

ReasonType

ReasonTypeText

ReasonTypeID

 

 

R_8301

R_8301

ReasonType

Reason

ReasonTypeID

 

 


2